-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[BAEImisDuesUpdatePrice]
    -- Add the parameters for the stored procedure here
    @Id as varchar(10),
    @ProductCode as varchar(31),
    @Price as money
    
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    UPDATE Subscriptions
    SET BILL_AMOUNT = @Price, BALANCE = @Price, BEGIN_DATE = null,
        PAID_THRU = null, FIRST_SUBSCRIBED = null
    WHERE ID = @Id and PRODUCT_CODE = @ProductCode;

END

GO